
clear

set more off
use QCEWannual.dta
keep if year==2006

 foreach num of numlist 1/20 {
  gen share`num'=inc`num'/inc0
  gen empshare`num'=emp`num'/emp0
 }
 keep cbsa share* empshare*
 
 save IndEmpShare06, replace
***2002 emp share
use QCEWannual.dta, clear
keep if year==2002
 foreach num of numlist 1/20 {
  gen empshare02_`num'=emp`num'/emp0
 }
 
  keep cbsa empshare*
  
  save EmpShare02, replace
